What is the best way to get data into my SQL server tables from SAS tables?
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.

Suggestions?

Thanks

Ross

I am running ODBC queries from Excel to pull data from an SQL2000 server.
In my query editor I have:

SELECT OL.Item, OL.Item_Desc, OL.Qty
FROM TestDatabase.dbo.OurLib OL
ORDER OL.Item

It returns the data but has a header from the SELECT statement.

Can anyone help?

DG

I'm working in a developer environment, trying to troubleshoot a problem in
a client's db. All I need to do is restore the db and configure an ODBC data
source.

I have SQL Server 2005 Express installed and an getting the 4gb limitation
error when I try to restore the client's db.

Do I have any other options to use the db, given that I am working in a
developer environment?

I recall older versions of MS-Office Developer shipping with SQL Server
developer licenses as well as Visual Basic 6.0 (both of which I have).

Here’s my question: What is the demand on SQL Server when running a client
mdb which uses many ODBC connections? Lets say maybe a dozen tables linked by
ODBC and many calls to SP’s and views where connection strings open and close
the link to SQL Server. How could this be measured against an adp?
Thanks,
Mark

I have an application that connects to a SQL Server database using ODBC. The
application runs fine with SQL Server 2000, 2005, and 2005 Express. I tried
with SQL Server 2008 Express and my application now spends the majority of
the time at 100%% CPU usage. I have tried to search the web for similar
occurance but have had no luck. I would like to be able to tell our clients
that upgrading SQL Server will not be a problem but right now I am not sure.
Any help is appreciated.

I have a client software connecting to my SQL 2000 DB (running on SQL Server
9.0.3054). When they perform some operations on the client (which results
in adding records to various db tables), it returns the error:

"Either BOF or EOF is True, or the current record has been deleted; the
operation requested by the application requires a current record."

This occurs everytime the user performs this type of operation, except for
Thursdays! I talked to my network ppl and nothing of note occurrs on
wednesday night.

I perform a reBuild Index, check DB Integrity and, full backup every night.

What could be going on?
TCorp.

Hello,

A client is having a problem inserting data from his Access application.
When I opened a table via Enterprise Manager and tried to enter a record I
got this error:
[Microsoft][ODBC SQL Server Driver]The log file for database 'STSIData' is
full. Back up the transaction log fot the database to free up log space.

What does this mean and how can this be corrected? Can it be handled
remotely? I hope to get it corrected today so that they can take orders on
Tuesday.

Thank you for any help and God Bless,

Mark A .Sam

I can't seem to find anything in the documentation about maximum sizes
for binding C strings. I'm getting an invalid precision error (HY104)
when attempting to bind a string of approximately 16k. This is being
inserted into a text column in the database. (using SQL_C_CHAR /
SQL_CHAR).

Is there a limit on the size here? If so, where is this documented and
what is the alternative for inserting long strings into text fields?

I have an issue that has plagued me for some time now. I cannot find
anything when I Google it or search the Business Objects forums, so
hopefully I will be able to find an answer here. I am using Crystal
Reports version 10. I am connecting to a SQL 2000 database using ODBC
(RDO). When previewing the report I am prompted for connection
information, I selected "Trusted Connection:" vs. entering the
username and password. Now when I try to view the report through the
application it was created for I receive the following error: "Unable
to connect: incorrect log on parameters." It seems that the report is
not using the correct credentials to access the database. The report
also does not prompt me for a username and password when I try to
preview it through CR 10. I don't know if my network...

I have a SQL Server 2000 setup in our DMZ with ports open from the LAN into
the DMZ. When I try to setup an ODBC connection for MS Aceess so I can get
data links setup from the LAN to the SQL Server it fails. In setting up the
ODBC Connection I get to where it lists the available SQL servers and it
finds our servers inside the LAN but not the SQL Server in the DMZ. I try
to put in the IP Address in place of the system name and I get nothing.
Does this sound like a open port concern? If so, what ports other than 1433
need to be open? What is the best way to troubleshoot this issue?

I am desperate for help on this issue and simply not sure where to turn.