[Microsoft][ODBC Text Driver] In The File Specification '...', The Col1 Option Is Invalid.
Mar 23, 2007
I'm trying to connect to a tab-delimited text file using the ODBC data access. I set it up using Administrative Tools - Data Sources (ODBC) from the start menu, and clicked the 'Guess' button under Define Format.
It looks OK, but if I go back to Define in Administrative Tools and try to review it, I get a similar error message:
Ini File (or Registry) C:Program FilesCIMSschema.ini is corrupt.
Section: cims_output_data.txt, Key: Col1.
Has anyone seen this before? There is nothing on MSDN as far as I could find. I read on another forum that if you replace the label 'Col1' with 'Col' the problem is solved but it still reports that the schema is corrupt when I try to open it in Administrative Tools.
Hello All,I am getting the following error when attemping to open a table inSQL2kSP3a.________________________________________SQL Server Enterprise ManagerDatabase Server: Microsoft SQL ServerVersion: 08.00.0760Runtime Error: [Microsoft][ODBC SQL Server Driver]Invalid time format_________________________________________I cannot find it in sysmessages, or on the web.Any ideas about how to resolve this? And how it occured...Thanks,TGru*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
Hi all--Given a table called "buyers" with the following column definitions in a SQL Server 2005 database:
[BUYER] [nvarchar](40) NULL,
[DIVISION] [nvarchar](3) NULL,
[MOD_DATE] [datetime] NULL
This table is laden with Unicode data and the MOD_DATE contains no data--not even NULL values, and is giving me a headache as a result. I can export this data fine to a text file, but when I create an SSIS package to attempt import to another table defined exactly the same as above in another place, I get the following messages:
SSIS package "buyers_import.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Source - buyers_txt [1]: The processing of file "D: emp3uyers.txt" has started. Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning. Information: 0x402090DE at Data Flow Task, Source - buyers_txt [1]: The total number of data rows processed for file "D: emp3uyers.txt" is 232. Error: 0xC0202009 at Data Flow Task, Destination - buyers_tst [22]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". Error: 0xC020901C at Data Flow Task, Destination - buyers_tst [22]: There was an error with input column "MOD_DATE" (45) on input "Destination Input" (35). The column status returned was: "The value could not be converted because of a potential loss of data.". Error: 0xC0209029 at Data Flow Task, Destination - buyers_tst [22]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (35)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (35)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - buyers_tst" (22) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited. Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning. Information: 0x402090DD at Data Flow Task, Source - buyers_txt [1]: The processing of file "D: emp3uyers.txt" has ended. Information: 0x402090DF at Data Flow Task, Destination - buyers_tst [22]: The final commit for the data insertion has started. Information: 0x402090E0 at Data Flow Task, Destination - buyers_tst [22]: The final commit for the data insertion has ended. Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning. Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - buyers_tst" (22)" wrote 0 rows. Task failed: Data Flow Task SSIS package "buyers_import.dtsx" finished: Failure.
Among the customizations in this package is the flag "ValidateExternalMetadata" set to False. The data itself is surrounded by " and delimited by semicolons for each field, with the header row set as the name of each column. It looks like this:
"BUYER";"DIVISION";"MOD_DATE" "108 Joon-Hyn Kim";"TAD";"" "109 Kang-Soo Do";"TAD";"" "FS07 John Smith";"TAD";""
...
Can anyone suggest a course of action on how to handle the error when the MOD_DATE field is completely empty?
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy
trying to install sql server2005 on a windows 2003 server box.
getting msg below at the sql server . i looked at other posts on trying to uninstall SQL Native Access Client and norton antivirus. i could never find the snac on the add - remove programs and this server does not have a virus protection program yet.
here's the history of the installs on the server:
wanted to test a 2005 upgrade so:
1) installed sql server 2000 then sp4 then restored some databases to it - all OK
2) tried to upgrade to sql 2005 but ran into problems and left it at that.
had a disk drive crash on the d drive so lost the installs but not the operating system
when the drive was replaced, left alone for a while
then wanted to test a straight 2005 install
1) removed the broken 2005 attempt
2) removed the 2000
3) installed 2005 and got the error on the subject line:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
i've gone through as many of the forums that i can and have tried several things - like uninstalling 2005 and installing pieces and parts but but nothing seems to work.
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application. --------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
odbc_pconnect() [function.odbc-pconnect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded., SQL state S1001 in SQLConnect
we got the error with access 2000 database and PHP as prog. language .
we created dsn for the connection.
reboot solves the problem. but we need another solution better than this.
I am using VB.NET 2005 and set up an ODBC connection via ODBC.ODBCConnection to a MDB database. Therefor, I use the "Microsoft Access ODBC Driver (*.mdb)".
When I set up a ODBCCommand like "ALTER DATABASE..." or "CREATE TABLE..." and issue it with the com.ExecuteNonQuery() command, I get an error from ODBC driver, that a SQL statement has to begin with SELECT, INSERT, UPDATE or DELETE.
How can I use DDL statements via ODBC?
I would appreciate if you could help me to use ODBC for that - no OLE, no ADO.
I am getting the below error when I try to access the table in 2005 database through 3rd party application from the application server.
“[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt�
This database was restored from sqlserver 2000, so the ODBC connection in the application server first was pointing to 2000 database and now its dropped and recreated to point to the 2005 database.
I dont get this error message when I do the same action from my pc.
I google'd on this error message, and I am not sure if the driver has to be upgraded or if there is anything else that I am missing here.
Well i have one question regarding the Timeout . I have an SQL SERVER 2005 database and have an VB6.0 application. I have a stored procedure which inserts more than 90,000 rows from one table to another . Some times i get an exception as [Microsoft] [ODBC SQL Driver] Timeout Expired in the Visual Basic application and some times it works fine. The exception i receive within 30 seconds , but when i try the same stored procedure in query analyser , it works fine. also i have increased the timeout in visual basic , but still i get the same error.
I am running a query which pulls back about 200,000 records.
When I run this in ISQL (SQL Server 6.5), it runs in almost 2 minutes. When I put it in a store procedure and run it off my ASP application, I get this error
[Microsoft][ODBC SQL Server Driver]Timeout Expired
We've tried many things including: 1) Increased connection and command time outs in Global ASA 2) Have the ODBC driver log long Quires to a file 3) Changed Query Time out in Enterprise Manager(360 seconds) Go to tools --> Preferences/configure -->Connection Tab 4) Changed Maximum allowed open database from 20 to 200 5) Changed resource timeout to 360 seconds from 5 seconds 6) Changed remote query timeout to 0, allowing infinite wait.
I inherited some really twisted asp pages from another developer that crank for a long time. They used to work, albeit slowly. Now when I try to run one I get the error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Short queries run fine.
IIS4 & SQL Server are on the same box. I didn't the ASP pages or the IIS or SQL server config. I did install VStudio 6.0 a while back.
Thank you to all who reply to this perplexing question. Mike
Database VMFGSRVRVMFG is SQL 2000 Std. Database NT002P_GL is SQL 7.0. All SQL versions are at the current SP levels.
I receive the timeout message when I am in EM, database,VMFG(database), Views, Open View, Return All Rows. I can successfully run the code in QA. I believe I am running up against a time parameter in SQL Server. I have reviewed all time parameters that I can find. However, I still receive the error. What parameters should I be looking at? I am attempting to create a view with the following code: -------------- CREATE view uv_olap_adj_co_profit as select customer.id as customer_number, customer.name as customer_name, customer_order.salesrep_id as salesperson, isnull(customer.country, 'USA') as country, '7' as business_unit, customer_order.order_type as order_type, uv_olap_co_profit.customer_order, uv_olap_co_profit.work_order, uv_olap_co_profit.close_date, uv_olap_co_profit.period_year, uv_olap_co_profit.gl_period, isnull((uv_olap_co_profit.billing + ut_man_adj.billing) *ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing, isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as material, isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor) *ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor, isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden) *ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden, uv_olap_co_profit.service_cost as service from uv_olap_co_profit, ut_man_adj, ut_fin_adj, customer_order, customer where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and uv_olap_co_profit.work_order *= ut_man_adj.work_order and uv_olap_co_profit.period_year = ut_fin_adj.year and uv_olap_co_profit.customer_order = customer_order.id and customer_order.customer_id = customer.id and (customer_order.salesrep_id = 'LABELAIREP' or customer_order.salesrep_id = 'OMOHUNDR' or customer_order.salesrep_id = 'EGGERSR') union all select customer.id as customer_number, customer.name as customer_name, customer_order.salesrep_id as salesperson, isnull(customer.country, 'USA') as country, customer.user_2 as business_unit, customer_order.order_type as order_type, uv_olap_co_profit.customer_order, uv_olap_co_profit.work_order, uv_olap_co_profit.close_date, uv_olap_co_profit.period_year, uv_olap_co_profit.gl_period, isnull((uv_olap_co_profit.billing + ut_man_adj.billing) *ut_fin_adj.billing, uv_olap_co_profit.billing*ut_fin_adj.billing) as billing, isnull((uv_olap_co_profit.material_cost + ut_man_adj.material)*ut_fin_adj.material, uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as material, isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor) *ut_fin_adj.labor, uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor, isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden) *ut_fin_adj.burden, uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as burden, uv_olap_co_profit.service_cost as service from uv_olap_co_profit, ut_man_adj, ut_fin_adj, customer_order, where uv_olap_co_profit.customer_order *= ut_man_adj.cust_order_id and uv_olap_co_profit.work_order *= ut_man_adj.work_order and uv_olap_co_profit.period_year = ut_fin_adj.year and uv_olap_co_profit.customer_order = customer_order.id and customer_order.customer_id
I've tried every websearch possible to try and get a solution for this problem but can't.
Development Software: SQL Server 2000 Enterprise Manager 8.0 Query Analyzer 8.00.194
Error: When I run a mildly complex view in Enterprise Manager I get the error:[Microsoft][ODBC SQL Server Driver]Timeout Expired after about 30 seconds.
When I copy and paste and run the exact same code in Query Analyzer the Query runs for longer than 30 seconds and runs until completion. Now my question is since this apparently seems to be an Enterpise Manager problem and not on the server end, where do I go in Enterprise Manager to change that setting? I've looked everywhere in Enterpise manager and can't find a "command timeout" setting.
Hello, I installed MS SQL Server 2000 Evaluation Edition on Windows XP Pro. I have database on the same PC. When I am running a query(view) from Query Analyser I get "[Microsoft][ODBC SQL Server Driver] Timeout Expired" error message . When I am running the same view on smaller amount of data it works.
I have tried updating the DSN configure option i.e. 30000 milliseconds.
But I am still facing the problem of Timeout Expired.
I am using sql server 2005 for daily importing data from Excel Dump Files into sql server table. Everyday the database gets updated. The Error mentioned in Subject normally gets once a month, due to daily updation of database whether each table structure gets changed like index, trigger, etc.
All, I need a help from you all. I am getting this error if the users are running the application which is connecting from MSAccess97 to SQL Server 2000. Error: [Microsoft][ODBC SQL Server Driver]Communication link failure I would appreciate if you send me the resolution for this problem. Thanks, Reddy
I get the message Microsoft [ODBC Sql server driver]communication link failure error message in my VB 6 application with MSDE engine. This error does not happen often. My connection string is as below.
Ive got a collection of view which piece together data from varying sources and assemble it ready for a stored procedure to squirt the data into a table.
This has worked fine up til yesterday when i had to amend one of the views to include a reference to another data set.
Essentially the data is for students and comes from our old db and our new one, each year group has different values so the views act to extract all data relevant for a child from both databases and accross all year data sets.
The problem im having is that i can get the final stored procedure to run. It ran fine the other day but since ive amended one of the views i get timeout errors wherever it's run. real problem when query analyser which has no timeout settings (apparently) times out as it means i cant run the query anywhere....enterprise manager will timeout after 30secs despite amending the query timeout setting to 600s.
so im a bit stuck, both views which the problem view is trying to combine run in under 30 seconds...when you try and combine them it times out- seems to run for a long long time.
note sure why this has started happening, from all ive read most peeps get this with EM and solve it using QA. but what if QA cant handle the query either?
heres the sql: (wont make much sense but hopefully shows that its not a complex query)
SELECT TOP 100 PERCENT dbo.StudentDetMaster.SetId, dbo.StudentDetMaster.StudentId, dbo.StudentDetMaster.Name, dbo.StudentDetMaster.CourseYear, dbo.StudentDetMaster.House, dbo.StudentDetMaster.Tutor, dbo.PGJSProfile.[Key Stage 1 Reading], dbo.PGJSProfile.[Key Stage 1 Writing], dbo.PGJSProfile.[Key Stage 1 Speaking & Listening], dbo.PGJSProfile.[Key Stage 1 Maths], dbo.PGJSProfile.[Key Stage 2 English], dbo.PGJSProfile.[Key Stage 2 Maths], dbo.PGJSProfile.[Key Stage 2 Science], dbo.PGJSProfile.[Verbal Reasoning Year 3], dbo.PGJSProfile.[Year 3 English Autumn], dbo.PGJSProfile.[Year 3 English Year Group Average], dbo.PGJSProfile.[Year 3 English Summer], dbo.PGJSProfile.[Year 3 English Year Group Average Score], dbo.PGJSProfile.[Year 3 Maths Autumn], dbo.PGJSProfile.[Year 3 Maths Year Group Average], dbo.PGJSProfile.[Year 3 Maths Summer], dbo.PGJSProfile.[Year 3 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 3 Maths Set], dbo.PGJSProfile.[Verbal Reasoning Year 4], dbo.PGJSProfile.[Year 4 English Autumn], dbo.PGJSProfile.[Year 4 English Year Group Average], dbo.PGJSProfile.[Year 4 English Summer], dbo.PGJSProfile.[Year 4 English Year Group Average Score], dbo.PGJSProfile.[Year 4 Maths Autumn], dbo.PGJSProfile.[Year 4 Maths Year Group Average], dbo.PGJSProfile.[Year 4 Maths Summer], dbo.PGJSProfile.[Year 4 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 4 Maths Set], dbo.PGJSProfile.[Verbal Reasoning Year 5], dbo.PGJSProfile.[Year 5 English Autumn], dbo.PGJSProfile.[Year 5 English Year Group Average], dbo.PGJSProfile.[Year 5 English Summer], dbo.PGJSProfile.[Year 5 English Year Group Average Score], dbo.PGJSProfile.[Year 5 Maths Autumn], dbo.PGJSProfile.[Year 5 Maths Year Group Average], dbo.PGJSProfile.[Year 5 Maths Summer], dbo.PGJSProfile.[Year 5 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 5 Maths Set], dbo.PGJSProfile.[Verbal Reasoning Year 6], dbo.PGJSProfile.[Year 6 English Autumn], dbo.PGJSProfile.[Year 6 English Year Group Average], dbo.PGJSProfile.[Year 6 English Year Group Average Score], dbo.PGJSProfile.[Year 6 Maths Autumn], dbo.StudentDetMaster.[Year 6 Maths Set], dbo.StudentDetMaster.[JS Baseline], dbo.PGJSProfile.[Year 6 English Mock], dbo.PGJSProfile.[Year 6 Maths Mock], dbo.PGJSProfile.[Year 6 English Mock Year Group Average], dbo.PGJSProfile.[Year 6 Maths Mock Year Group Average] FROM dbo.PGJSProfile LEFT OUTER JOIN dbo.StudentDetMaster ON dbo.PGJSProfile.SetId = dbo.StudentDetMaster.SetId AND dbo.PGJSProfile.StudentId = dbo.StudentDetMaster.StudentId ORDER BY dbo.StudentDetMaster.Name
Hi,I have a php application connected through odbc to a sqlserver database.When I try to execute select queries on a smalldatetime table field Ireceive this message:Warning: [22003][0][Microsoft][ODBC SQL Server Driver]Numeric value out ofrangeThe query is something like:select dateField from tableTha field is a normal smalldatetime one:10/17/2001 12:35:00 PMWhith Query Analyzer the query works fine.I'm using php mssql_query() and ODBTP as protocol to connect to the DBMSThanksLuigi--Message posted via http://www.sqlmonster.com
Several of our customers are getting a message intermitantly throughout the day where the connection is closed. The message being generated is [Microsoft][ODBC SQL Server Driver]Communication Link Failure.
These messages started in the last two weeks.
Thanks for any direction that can be thrown my way.
Hi guys! I am using SQL 2005 and I wonder why I am encountering the error "[Microsoft][ODBC SQL Server Driver]Syntax error or access violation" everytime I am trying to create stored procedure with temp table and table variable. See my code below with temp table.
Any thoughts will be appreciated!
CREATE PROCEDURE DBO.SAMPLESP (@DETAILS AS VARCHAR(8000), @ID AS VARCHAR(15))
AS
BEGIN TRANSACTION
CREATE TABLE DBO.#TEMPTABLE { ASSET VARCHAR(50) }
DECLARE @INSTINSERT AS NVARCHAR(4000) SET @INSTINSERT= 'INSERT INTO #TEMPTABLE(ASSET)' SET @INSTINSERT= @INSTINSERT+ @DETAILS
EXEC sp_ExecuteSQL @INSTINSERT
INSERT INTO InstDetail (TrackNum, ASSETID) SELECT @ID, A.ASSE FROM #TEMPTABLE A
DROP TABLE #TEMPTABLE
IF @@ERROR != 0 BEGIN ROLLBACK TRANSACTION RAISERROR('There was an error in here', 11, 1) RETURN END ELSE COMMIT TRANSACTION
In order to add a data source by using ODBC Administrator, programmatically i am using SQLConfigDataSource. Thus calling SQLConfigDataSource with the fOption set to either ODBC_ADD_DSN for creating a new DSN.
Following is the stattement specified in the source code. where type_of_driver = "Microsoft Access Driver (*.mdb)"; and parameters contains the data source source credentials information such as DSN, UID, PSW, FIL, Description, DataDirectory,DEFAULTDIR and DBQ all separated by " ".
after execution of below mentioned command an error is encountered i.e -1 is returned if the DataDirectory path exceeds certain nested directories link. for eg. the file path specified below.
C:My DocumentsClients CurrentAHW Netcare BenefitsDeliverables1-5 Results Chain - system LevelAlberta NetcareBenefits Logic System Level V01.rcm
Creating a datasource with the file name i.e Benefits Logic System Level V01 every time. rc = :: SQLConnect(hDbc, (unsigned char *)szSource, SQL_NTS, (unsigned char *)szUserName, SQL_NTS, (unsigned char *)szPassword, SQL_NTS);
Also following error message was encountered during execution of SQLConnect command.
/*szErrorMsg = 0x0012e834 "[Microsoft][ODBC Microsoft Access Driver]General error Not enough information to connect to this DSN with SQLConnect. Use SQLDriverConnect."*/
Thus followed the instruction smentioned in the error message an dtried using SQL DriverConnect() in the following manner. rc = :: SQLDriverConnect(hDbc, NULL,(SQLCHAR *)"DSN=RCM",SQL_NTS,outstr, sizeof(outstr), &outstrlen,SQL_DRIVER_NOPROMPT);
Still an error is encountered but this time it returns a RETCODE of 100 whrease earlier it had returned -1.
Inform the procedure to be followed using SQLConnect when DataDirectory path is too long.
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
