I bought a new desktop with Windows 7 64bit. I transferred all necessary software for SQL tools and pbcc5.2 to the new computer. I had a program
that was running under XP. I changed the DNS to match the correct path for the new computer. I was able to run the program successfully on the
new computer. Here is a copy of the DSN.
[ODBC]
DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=excel 12.0
DriverId=1046
DefaultDir=C:\users\tom kroto\Documents
DBQ=C:\users\tom kroto\Documents\checkbook7.xlsx
I've been attempting to create a new DSN. This new DSN is exactly like the one that was working except for a change to the Excel workbook. This
is the error that I received -- a connection could not be made using the file data source parameters entered.
I went back to the old computer and went through the same steps. Instead of the error message I did get to the screen that says ODBC Microsoft
Excel setup. It had the Excel 12.0 listed and I selected the workbook. It worked fine.
I could easily just take the original DSN and make a copy for the new workbook with minor changes. But I want to know why this is failing on the
new desktop. It can't be because the driver is not present since the first program worked perfectly. Any ideas? Thank you.
that was running under XP. I changed the DNS to match the correct path for the new computer. I was able to run the program successfully on the
new computer. Here is a copy of the DSN.
[ODBC]
DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
UID=admin
UserCommitSync=Yes
Threads=3
SafeTransactions=0
ReadOnly=1
PageTimeout=5
MaxScanRows=8
MaxBufferSize=2048
FIL=excel 12.0
DriverId=1046
DefaultDir=C:\users\tom kroto\Documents
DBQ=C:\users\tom kroto\Documents\checkbook7.xlsx
I've been attempting to create a new DSN. This new DSN is exactly like the one that was working except for a change to the Excel workbook. This
is the error that I received -- a connection could not be made using the file data source parameters entered.
I went back to the old computer and went through the same steps. Instead of the error message I did get to the screen that says ODBC Microsoft
Excel setup. It had the Excel 12.0 listed and I selected the workbook. It worked fine.
I could easily just take the original DSN and make a copy for the new workbook with minor changes. But I want to know why this is failing on the
new desktop. It can't be because the driver is not present since the first program worked perfectly. Any ideas? Thank you.
Comment